/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_prod_comp_role_his.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_PROD_COMP_ROLE_HIS
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_prod_comp_role_his.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "table_ppm.h"

CTable_PPM_PROD_COMP_ROLE_HIS::CTable_PPM_PROD_COMP_ROLE_HIS( )
 :NPCRecordSet( )
{
  setTableName( "PPM_PROD_COMP_ROLE_HIS" );
  prepareTable();
  prepareQuery();
 
  HIS_ID.setField( "HIS_ID", DATA_CHAR, 20, 1 );
  makeTableItem( HIS_ID );
  makeKeyItem( HIS_ID ); 
  APP_ID.setField( "APP_ID", DATA_CHAR, 20, 0 );
  makeTableItem( APP_ID );
  PRODUCT_NBR.setField( "PRODUCT_NBR", DATA_CHAR, 30, 0 );
  makeTableItem( PRODUCT_NBR );
  PROD_COMP_ROLE_CD.setField( "PROD_COMP_ROLE_CD", DATA_DOUBLE, 22, 2 );
  makeTableItem( PROD_COMP_ROLE_CD );
  makeKeyItem(PROD_COMP_ROLE_CD);
  PROD_ROLE_NAME.setField( "PROD_ROLE_NAME", DATA_CHAR, 64, 0 );
  makeTableItem( PROD_ROLE_NAME );
  UP_PROD_ROLE_CD.setField( "UP_PROD_ROLE_CD", DATA_DOUBLE, 22, 0 );
  makeTableItem( UP_PROD_ROLE_CD );
  ROLE_MIN_NUM.setField( "ROLE_MIN_NUM", DATA_DOUBLE, 22, 0 );
  makeTableItem( ROLE_MIN_NUM );
  ROLE_MAX_NUM.setField( "ROLE_MAX_NUM", DATA_DOUBLE, 22, 0 );
  makeTableItem( ROLE_MAX_NUM );
  ROLE_STD_CODE.setField( "ROLE_STD_CODE", DATA_CHAR, 100, 0 );
  makeTableItem( ROLE_STD_CODE );
  EXIST_TYPE.setField( "EXIST_TYPE", DATA_CHAR, 20, 0 );
  makeTableItem( EXIST_TYPE );
  APP_STATE.setField( "APP_STATE", DATA_CHAR, 20, 0 );
  makeTableItem( APP_STATE );
  DESCRIPTION.setField("DESCRIPTION" , DATA_CHAR , 4000 , 0 );
  makeTableItem(DESCRIPTION);
}


CTable_PPM_PROD_COMP_ROLE_HIS::CTable_PPM_PROD_COMP_ROLE_HIS( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_PROD_COMP_ROLE_HIS" );
  prepareTable();
  prepareQuery();
 
  HIS_ID.setField( "HIS_ID", DATA_CHAR, 20, 1 );
  makeTableItem( HIS_ID );
  makeKeyItem( HIS_ID ); 
  APP_ID.setField( "APP_ID", DATA_CHAR, 20, 0 );
  makeTableItem( APP_ID );
  PRODUCT_NBR.setField( "PRODUCT_NBR", DATA_CHAR, 30, 0 );
  makeTableItem( PRODUCT_NBR );
  PROD_COMP_ROLE_CD.setField( "PROD_COMP_ROLE_CD", DATA_DOUBLE, 22, 2 );
  makeTableItem( PROD_COMP_ROLE_CD );
  makeKeyItem(PROD_COMP_ROLE_CD);
  PROD_ROLE_NAME.setField( "PROD_ROLE_NAME", DATA_CHAR, 64, 0 );
  makeTableItem( PROD_ROLE_NAME );
  UP_PROD_ROLE_CD.setField( "UP_PROD_ROLE_CD", DATA_DOUBLE, 22, 0 );
  makeTableItem( UP_PROD_ROLE_CD );
  ROLE_MIN_NUM.setField( "ROLE_MIN_NUM", DATA_DOUBLE, 22, 0 );
  makeTableItem( ROLE_MIN_NUM );
  ROLE_MAX_NUM.setField( "ROLE_MAX_NUM", DATA_DOUBLE, 22, 0 );
  makeTableItem( ROLE_MAX_NUM );
  ROLE_STD_CODE.setField( "ROLE_STD_CODE", DATA_CHAR, 100, 0 );
  makeTableItem( ROLE_STD_CODE );
  EXIST_TYPE.setField( "EXIST_TYPE", DATA_CHAR, 20, 0 );
  makeTableItem( EXIST_TYPE );
  APP_STATE.setField( "APP_STATE", DATA_CHAR, 20, 0 );
  makeTableItem( APP_STATE );
  DESCRIPTION.setField("DESCRIPTION" , DATA_CHAR , 4000 , 0 );
  makeTableItem(DESCRIPTION);
}

CTable_PPM_PROD_COMP_ROLE_HIS::~CTable_PPM_PROD_COMP_ROLE_HIS( )
{
    close();
}

